﻿CREATE TABLE [dbo].[Measurement_Tbl] (
    [MeasurementID]              INT            IDENTITY (1, 1) NOT NULL,
    [SecondTrack]                BIT            NOT NULL,
    [InnerStay]                  BIT            NOT NULL,
    [MizzenMast]                 BIT            NOT NULL,
    [MizzenStay]                 BIT            NOT NULL,
    [LWL]                        FLOAT          NULL,
    [LOA]                        FLOAT          NULL,
    [BowSheer]                   FLOAT          NULL,
    [MastSheer]                  FLOAT          NULL,
    [SheetSheer]                 FLOAT          NULL,
    [BowFwd]                     FLOAT          NULL,
    [BowRake]                    FLOAT          NULL,
    [Track1Fwd]                  FLOAT          NULL,
    [Track1Aft]                  FLOAT          NULL,
    [TransomLength]              FLOAT          NULL,
    [TransomDepth]               FLOAT          NULL,
    [GuardRailHeight]            FLOAT          NULL,
    [I]                          FLOAT          NULL,
    [J]                          FLOAT          NULL,
    [FL]                         FLOAT          NULL,
    [P]                          FLOAT          NULL,
    [E]                          FLOAT          NULL,
    [BAD]                        FLOAT          NULL,
    [MastWidth]                  FLOAT          NULL,
    [MainSailMaxLeech]           FLOAT          NULL,
    [GenoaMaxluff]               FLOAT          NULL,
    [GenoaMaxLeech]              FLOAT          NULL,
    [GenoaMaxTackHeight]         FLOAT          NULL,
    [BackStayAft]                FLOAT          NULL,
    [ChainPlateAft]              FLOAT          NULL,
    [SpreaderString]             NVARCHAR (50)  NULL,
    [RunnerHeight]               FLOAT          NULL,
    [RunnerAft]                  FLOAT          NULL,
    [Track2Fwd]                  FLOAT          NULL,
    [Track2Aft]                  FLOAT          NULL,
    [Iss]                        FLOAT          NULL,
    [Js]                         FLOAT          NULL,
    [Iy]                         FLOAT          NULL,
    [Jy]                         FLOAT          NULL,
    [Fly]                        FLOAT          NULL,
    [Py]                         FLOAT          NULL,
    [Ey]                         FLOAT          NULL,
    [BADy]                       FLOAT          NULL,
    [MizzenMaxLeech]             FLOAT          NULL,
    [Isy]                        FLOAT          NULL,
    [Jsy]                        FLOAT          NULL,
    [CreationDate]               NVARCHAR (50)  NULL,
    [SpecBoatID]                 INT            NULL,
    [SailMeasurement]            BIT            NOT NULL,
    [BoatType]                   NVARCHAR (50)  NULL,
    [BoatModel]                  NVARCHAR (50)  NULL,
    [BoatName]                   NVARCHAR (50)  NULL,
    [BoatManufacturer]           NVARCHAR (50)  NULL,
    [HullNumber]                 NVARCHAR (50)  NULL,
    [SailNumber]                 NVARCHAR (50)  NULL,
    [FurlingGear]                NVARCHAR (50)  NULL,
    [LastUpdated]                NVARCHAR (50)  NULL,
    [CustomerID]                 INT            NULL,
    [BoatGenID]                  INT            NULL,
    [BoatRange]                  NVARCHAR (50)  NULL,
    [OrderID]                    INT            NULL,
    [ConcatString]               NVARCHAR (MAX) NULL,
    [RigManufacturer]            NVARCHAR (50)  NULL,
    [RigType]                    NVARCHAR (50)  NULL,
    [QuoteID]                    INT            NULL,
    [LWL_Amended]                BIT            NULL,
    [BowSheer_Amended]           BIT            NULL,
    [MastSheer_Amended]          BIT            NULL,
    [SheetSheer_Amended]         BIT            NULL,
    [BowFwd_Amended]             BIT            NULL,
    [BowRake_Amended]            BIT            NULL,
    [Track1Fwd_Amended]          BIT            NULL,
    [Track1Aft_Amended]          BIT            NULL,
    [TransomLength_Amended]      BIT            NULL,
    [TransomDepth_Amended]       BIT            NULL,
    [GuardRailHeight_Amended]    BIT            NULL,
    [FL_Amended]                 BIT            NULL,
    [BAD_Amended]                BIT            NULL,
    [MastWidth_Amended]          BIT            NULL,
    [MainSailMaxLeech_Amended]   BIT            NULL,
    [GenoaMaxLuff_Amended]       BIT            NULL,
    [GenoaMaxLeech_Amended]      BIT            NULL,
    [GenoaMaxTackHeight_Amended] BIT            NULL,
    [BackStayAft_Amended]        BIT            NULL,
    [ChainPlateAft_Amended]      BIT            NULL,
    [RunnerHeight_Amended]       BIT            NULL,
    [RunnerAft_Amended]          BIT            NULL,
    [Track2Fwd_Amended]          BIT            NULL,
    [Track2Aft_Amended]          BIT            NULL,
    [Iss_Amended]                BIT            NULL,
    [Js_Amended]                 BIT            NULL,
    [Iy_Amended]                 BIT            NULL,
    [Jy_Amended]                 BIT            NULL,
    [Fly_Amended]                BIT            NULL,
    [Py_Amended]                 BIT            NULL,
    [Ey_Amended]                 BIT            NULL,
    [BADy_Amended]               BIT            NULL,
    [MizzenMaxLeech_Amended]     BIT            NULL,
    [Isy_Amended]                BIT            NULL,
    [Jsy_Amended]                BIT            NULL
);

